Release 10.1A: OpenEdge Data Management:
DataServer for Microsoft SQL Server


Creating a schema holder

The MS SQL Server Utilities are located under the DataServer menu option in the Data Administration Tool. Progress Software Corporation recommends that you use the Create DataServer Schema option to pull in all the objects that your application needs. This will create the schema information as a database type of MSS instead of ODBC. After completing the schema pull, the schema needs to be adjusted to conform to OpenEdge behavior.

To adjust the schema after completing the pull:

  1. Connect to the original OpenEdge database.
  2. Select the DataServer MS SQL Server Utilities Schema Migration Tools Adjust Schema option to fix the OpenEdge attributes needed for your application to run. You can specify the entire schema holder or specific objects.

Copyright © 2005 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095